﻿use [clz]
-- =============================================
-- Author:		luohr
-- Create date: 2011-08-30
-- Description:	  添加表 AccountConfig
-- =============================================
if not exists (select 1
            from  sysobjects
           where  id = object_id('AccountConfig')
            and   type = 'U')
begin

/*==============================================================*/
/* Table: AccountConfig                                         */
/*==============================================================*/
create table AccountConfig (
   AccountConfigID      int                  identity,
   Title                nvarchar(50)         not null,
   ConfigName           nvarchar(50)         not null,
   ConfigValue          nvarchar(1000)       not null,
   DBTypeName           nvarchar(50)         not null,
   Description          ntext                null,
   constraint PK_ACCOUNTCONFIG primary key (AccountConfigID)
)

SET IDENTITY_INSERT [dbo].[AccountConfig] ON
INSERT [dbo].[AccountConfig] ([AccountConfigID], [Title], [ConfigName], [ConfigValue], [DBTypeName], [Description]) VALUES (1, N'支付宝帐户名', N'cfg_alipay_account_name', N'', N'nvarchar(100)', N'支付宝帐户名')
INSERT [dbo].[AccountConfig] ([AccountConfigID], [Title], [ConfigName], [ConfigValue], [DBTypeName], [Description]) VALUES (2, N'支付宝帐户', N'cfg_alipay_seller_email', N'', N'nvarchar(100)', N'商家Email')
INSERT [dbo].[AccountConfig] ([AccountConfigID], [Title], [ConfigName], [ConfigValue], [DBTypeName], [Description]) VALUES (3, N'支付宝合作伙伴Id', N'cfg_alipay_partnter', N'', N'nvarchar(100)', N'支付宝合作伙伴Id')
INSERT [dbo].[AccountConfig] ([AccountConfigID], [Title], [ConfigName], [ConfigValue], [DBTypeName], [Description]) VALUES (4, N'安全检验码', N'cfg_alipay_key', N'', N'nvarchar(100)', N'安全检验码')
SET IDENTITY_INSERT [dbo].[AccountConfig] OFF
end